{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,1,3,2],[11,1,11,7],[26,1,30,8]]}
[]
[null,"NHS Health Check Audit Wizard for Vision 3",null,null,null,null,null,null,null,null,"Search Criteria = Last one of the below:",null,null,"All codes are hierarchical"]
[null,null,null,null,null,null,null,null,null,null,"Description","Time","Entity","Codes"]
[null,"Enter Date Range",null,null,"=EOMONTH(TODAY(),-2)+1",null,null,null,null,null,"All Patients","Range","All Clinical","with a completed NHS Health Check in date range 8BAg or 8BAg0"]
[null,"FROM","TO",null,"=EOMONTH(TODAY(),-1)+1",null,null,null,null,null,"Ethnicity","< TO","All Clinical","9i, 9S, 9T, 9t"]
[null,{"$f":"EOMONTH(TODAY(),-5)+1","v":"2016-11-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2017-02-28"},null,null,null,null,null,null,null,"Consent to Share Data with Public Health","Range","All Clinical","9NdG, 9NdH"]
[null,null,null,null,null,null,null,null,null,null,"Invitation","Range","All Clinical","9mC0, 9mC1, 9mC2, 9mC3, 9mC4, 9mC6"]
[null,null,null,null,null,null,null,null,null,null,"Unsuccessful NHS Health Check","Range","All Clinical","8IAx, 9Nj5, 9NiS"]
[null,null,null,null,null,null,null,null,null,null,"NHS Health Check Completed","Range","All Clinical","8BAg "]
[null,null,null,null,null,null,null,null,null,null,"Place of Procedure","Range","All Clinical","8BAg0"]
[null,"1.  Enter a date range",null,null,null,null,null,null,null,null,"Results Communicated Face to Face","Range","All Tests","41C (Excluding 41C5)"]
[null,"2.  Click the compile button to start the automatic data extraction from Vision",null,null,null,null,null,null,null,null,"FH CVD","Ever","All Clinical","1224, 12C2, 12CV, 12CW, 12V"]
[null,"3.  This workbook will be minimised while the data is being compiled and restored once completed",null,null,null,null,null,null,null,null,"Pulse","Range","All Clinical",242]
[null,null,null,null,null,null,null,null,null,null,"Pulse Rhythm","Range","All Clinical","2431, 2432, 2433"]
[null,"NOTE:",null,null,null,null,null,null,null,null,"BMI","Range","Weight"]
[null,"This will only work if Vision is on DLM485 or above.",null,null,null,null,null,null,null,null,"BP","Range","BP"]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed",null,null,null,null,null,null,null,null,"Total Chol:HDL Ratio","Range","All Tests","44PF"]
[null,null,null,null,null,null,null,null,null,null,"Serum Cholesterol","Range","Cholesterol","44P, 44P1, 44P2, 44P3, 44P4"]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection",null,null,null,null,null,null,null,null,"Near Patient Testing","Range","All Clinical","9kD0"]
[null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security",null,null,null,null,null,null,null,null,"GPPAQ Scores","Range","All Clinical","138X, 138Y, 138a, 138b "]
[null,null,null,null,null,null,null,null,null,null,"Tobacco Consumptions","Range","Smoking"]
[null,"Current Version:",1.1000000000000001,"Written by:","Bradley Sieve",null,null,null,null,null,"Date Ceased smoking","Range","Smoking"]
[null,"Last updated:","2017-03-27","Email:",null,null,null,null,null,null,"Alcohol Consumptions","Range","Alcohol"]
[null,null,null,"Website:",null,null,null,null,null,null,"Brief intervention for excessive alcohol consumption completed ","Range","All Clinical","9k1A"]
[null,null,null,null,null,null,null,null,null,null,"Extended intervention for excessive alcohol consumption completed ","Range","All Clinical","9k1B"]
[null,"Disclaimer",null,null,null,null,null,null,null,null,"Audit C","Range","All Tests","38D4 "]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results.",null,null,null,null,null,null,null,null,"Audit","Range","All Tests","38D3"]
[null,null,null,null,null,null,null,null,null,null,"QRisk","Range","All Tests","38DF, 38DP"]
[null,null,null,null,null,null,null,null,null,null,"Dementia Awareness","Range","All Clinical","67DF"]
[null,null,null,null,null,null,null,null,null,null,"Laboratory Test Requested","Range","All Tests",413]
[null,null,null,null,null,null,null,null,null,null,"Blood Test Declined","Range","All Tests","41M"]
[null,null,null,null,null,null,null,null,null,null,"HbA1c ","Range","HbA1c","42W5"]
[null,null,null,null,null,null,null,null,null,null,"Fasting Glucose","Range","Fasting Glucose","44T2"]
[null,null,null,null,null,null,null,null,null,null,"Serum Creatinine","Range","Serum Creatinine","44J3"]
[null,null,null,null,null,null,null,null,null,null,"eGFR","Range","GFR","451E, 451F, 451G"]
[null,null,null,null,null,null,null,null,null,null,"Serum LDL Chol","Range","LDL","44P6"]
[null,null,null,null,null,null,null,null,null,null,"Serum Triglycerides","Range","Triglycerides","44Q, 44Q1, 44Q2, 44Q3"]
[null,null,null,null,null,null,null,null,null,null,"ECG","Range","ECG"]
[null,null,null,null,null,null,null,null,null,null,"Statin Offered","Range","All Clinical","8B31C"]
[null,null,null,null,null,null,null,null,null,null,"Meds for Hyperlipidaemia","Range","All Clinical","bx"]
[null,null,null,null,null,null,null,null,null,null,"Meds for Hypertension","Range","All Clinical","bk, bf, bg, bh, bi, bl, bd, b2"]
[null,null,null,null,null,null,null,null,null,null,"CKD","Ever","All Clinical","1Z1, K05"]
[null,null,null,null,null,null,null,null,null,null,"Type 2 Diabetes","Ever","All Clinical","C10F"]
[null,null,null,null,null,null,null,null,null,null,"Hypertension","Ever","All Clinical","G2"]
[null,null,null,null,null,null,null,null,null,null,"Non Diabetic Hyperglycaemia","Ever","All Clinical","66AJ0, C11y3, R105712, Ryu8A"]
[null,null,null,null,null,null,null,null,null,null,"Atrial Fibrillation","Ever","All Clinical","G573"]
[null,null,null,null,null,null,null,null,null,null,"Familial Hyperlipidaemia","Ever","All Clinical","C3200, C3204"]
[null,null,null,null,null,null,null,null,null,null,"Review Plan","Range","All Clinical","6B5"]
[null,null,null,null,null,null,null,null,null,null,"Follow-up Monitoring due","Range","All Clinical","9cOH"]
[null,null,null,null,null,null,null,null,null,null,">/= 20% 1 year high risk review ","Range","All Clinical","9Ox"]